/ Programmer Plus 2007 / Programmer-Plus-2007.iso / Programming / SQL and Data Base / Logic Works ERwin 3.5 / data.1 / ERTMPL32.DLL / RCDATA / 709

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 43 48 49 4c 44 20 49 4e | 53 45 52 54 20 53 45 54 |CHILD IN|SERT SET|
|00000010| 4e 55 4c 4c 00 21 20 45 | 52 77 69 6e 20 42 75 69 |NULL.! E|Rwin Bui|
|00000020| 6c 74 69 6e 20 25 44 61 | 74 65 74 69 6d 65 20 0d |ltin %Da|tetime .|
|00000030| 0a 21 20 25 50 61 72 65 | 6e 74 20 25 56 65 72 62 |.! %Pare|nt %Verb|
|00000040| 50 68 72 61 73 65 20 25 | 43 68 69 6c 64 20 4f 4e |Phrase %|Child ON|
|00000050| 20 43 48 49 4c 44 20 49 | 4e 53 45 52 54 20 53 45 | CHILD I|NSERT SE|
|00000060| 54 20 4e 55 4c 4c 20 0d | 0a 20 20 20 20 63 61 6c |T NULL .|.    cal|
|00000070| 6c 20 53 71 6c 49 6d 6d | 65 64 69 61 74 65 28 27 |l SqlImm|ediate('|
|00000080| 75 70 64 61 74 65 20 25 | 43 68 69 6c 64 0d 0a 20 |update %|Child.. |
|00000090| 20 20 20 20 20 73 65 74 | 0d 0a 20 20 20 20 20 20 |     set|..      |
|000000a0| 20 20 25 53 65 74 46 4b | 28 25 43 68 69 6c 64 2c |  %SetFK|(%Child,|
|000000b0| 4e 55 4c 4c 29 0d 0a 20 | 20 20 20 20 20 77 68 65 |NULL).. |     whe|
|000000c0| 72 65 0d 0a 20 20 20 20 | 20 20 20 20 6e 6f 74 20 |re..    |    not |
|000000d0| 65 78 69 73 74 73 20 28 | 0d 0a 20 20 20 20 20 20 |exists (|..      |
|000000e0| 20 20 20 20 73 65 6c 65 | 63 74 20 2a 20 66 72 6f |    sele|ct * fro|
|000000f0| 6d 20 25 50 61 72 65 6e | 74 0d 0a 20 20 20 20 20 |m %Paren|t..     |
|00000100| 20 20 20 20 20 20 20 77 | 68 65 72 65 0d 0a 09 09 |       w|here....|
|00000110| 25 46 6f 72 45 61 63 68 | 46 4b 41 74 74 28 22 61 |%ForEach|FKAtt("a|
|00000120| 6e 64 20 22 29 7b 20 25 | 50 61 72 65 6e 74 2e 25 |nd "){ %|Parent.%|
|00000130| 50 61 72 65 6e 74 41 74 | 74 28 25 41 74 74 46 69 |ParentAt|t(%AttFi|
|00000140| 65 6c 64 4e 61 6d 65 29 | 20 3d 20 3a 25 41 74 74 |eldName)| = :%Att|
|00000150| 46 69 65 6c 64 4e 61 6d | 65 20 7d 0d 0a 20 20 20 |FieldNam|e }..   |
|00000160| 20 20 20 20 20 29 20 61 | 6e 64 0d 0a 09 20 20 20 |     ) a|nd...   |
|00000170| 20 25 46 6f 72 45 61 63 | 68 46 4b 41 74 74 28 22 | %ForEac|hFKAtt("|
|00000180| 61 6e 64 20 22 29 7b 25 | 41 74 74 46 69 65 6c 64 |and "){%|AttField|
|00000190| 4e 61 6d 65 20 3d 20 3a | 25 41 74 74 46 69 65 6c |Name = :|%AttFiel|
|000001a0| 64 4e 61 6d 65 20 7d 27 | 29 0d 0a 00 1a 27       |dName }'|)....'  |
+--------+-------------------------+-------------------------+--------+--------+